Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
KeyCustomerCompositeSegmentID (PK) | Token ID for a given Key Customer Composite Segment. | ID_KY_CT_CMPST_SGMT | Identity | integer | |
CustomerID (FK) | A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. | ID_CT | Identity | integer | KeyCustomer(PA_KY_CT) |
DemographicSegmentID (FK) | Token ID for a DemographicSegment instance | ID_DMOG_SGMT | Identity | integer | CompositeDemographicSegment(CO_DMOG_SGMT) |
PsychographicSegmentID (FK) | Token ID for a composite psychographic customer segment. | ID_PSYCHGRPH_SGMT | Identity | integer | CompositePsychographicSegment(CO_PSYCHGRPH_SGMT) |
ActivityInterestCode (FK) | A lookup value that designates a valid activity or interest code used to segment customers. The code list must be defined by the retailer. | CD_ACTV_INTRST | Code | varchar(20) | ActivityInterest(CO_ACTV_INTRST) |
KeyIndividualCustomerCompositeSegmentDescription | Description of this COMPOSITE customer segment. The term individual here means we're looking at a PERSON party type vs. an organization. | DY_KY_INDVDL_CT_CMPST_SGMT | DescriptionShort | varchar(255) | |
EffectiveDate | Date a key customer - segment association is active and used to categorize individuals into segments. | DC_ER | EffectiveDate | date | |
ExpirationDate | Date a key customer - segment association is no longer active and used to categorize individuals into segments. | DC_EP | ExpirationDate | date | |
StatusCode | Indicates if this KeyCustomer - Segment association is active or inactive. Values: A- Active I - Inactive | CD_STS | Code2Status | char(2) | |
HealthSegmentID (FK) | Token ID for a Health-oriented customer composite segment | ID_HLTH_SGMT | Identity | integer | CompositeHealthSegment(CO_HLTH_SGMT) |